package com.pet.server.ext.service;

import com.pet.server.ext.ApiError;
import com.pet.server.ext.data.Page;
import com.pet.server.ext.data.ProductInfo;
import com.pet.server.ext.dbutil.JdbcTemplate;
import com.pet.server.ext.dbutil.Sql;


public class ProductService {
	private JdbcTemplate jdbcTemplate = new JdbcTemplate();

	public void searchProductInfo(Page page,String cate) throws ApiError{
		Sql sql = new Sql("SELECT p.* FROM product_info p WHERE 1=1");
		sql.append("AND", "p.product_cate", "=", cate);
		jdbcTemplate.search(page, sql, ProductInfo.class);
	}
	
	
}
